---USE [{WebDatabase}]
---GO
/****** Object:  Table [dbo].[SegmentDocument]    Script Date: 08/23/2007 16:34:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE
[dbo].[SegmentDocument]
(
	[SegmentId]  [int] NOT NULL
,   [DocumentId] [int] NOT NULL
)
ON [PRIMARY]

GO
ALTER TABLE [dbo].[SegmentDocument] WITH NOCHECK
ADD CONSTRAINT [FkSegmentDocument_Document] FOREIGN KEY([DocumentId])
REFERENCES [dbo].[Document] ([DocumentId])
GO
ALTER TABLE [dbo].[SegmentDocument] NOCHECK
CONSTRAINT [FkSegmentDocument_Document]
GO
ALTER TABLE [dbo].[SegmentDocument] WITH NOCHECK
ADD  CONSTRAINT [FkSegmentDocument_Segment] FOREIGN KEY([SegmentId])
REFERENCES [dbo].[Segment] ([SegmentId])
GO
ALTER TABLE [dbo].[SegmentDocument] NOCHECK
CONSTRAINT [FkSegmentDocument_Segment]